package com.online.dao;

import com.online.entity.Student;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface StudentMapper {

    Student selectByStudentNumber(String studentNumber);

    Student selectAStudent(@Param(value = "studentNumber") String studentNumber, @Param(value = "password") String password);

    Integer selectStatusByStudentNumber(String studentNumber);

    int deleteByStudentClass(String className);

    int insertARecord(Student student);

    List<Student> selectStudentByStudentClass(String studentClass);

    int deleteStudentById(Integer studentId);

    Student selectByStudentId(Integer studentId);

    int updateStudentStatus(@Param(value = "studentId") Integer studentId,@Param(value = "status") Integer status);

    int updateStudentInfo(@Param("id") Integer id,@Param("studentName") String studentName,@Param("password") String password,@Param("sex") String sex);


}
